home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 2,801 to 2,900
/
aol-file-protocol-4400-2801-to-2900.zip
/
AOLDLs
/
TAWUG
/
TAWUG Disk No. 25 (SHK)
/
TAWUG.25.shk
/
ACECALC.5X8
(
.txt
)
< prev
next >
Wrap
AppleWorks Document
|
1986-02-26
|
3KB
|
54 lines
O=====|====|====|====|====|====|====|====|====|====|====|====|====|====|====|===
ACECalc
CALCULATE COMMANDSQ
O/A set attribute /R reproduce ,
@IF(cond,v1,v2) If cond True then v1,Q
O D-Default A-All L-Labels ( invoke reproduce options '
If false then v2L
J V-Values P-Protect H-Hide A-Attributes only F-Formats 2
only @ISERROR(val) gives True if val is ERRORL
J/B blank contents of cell C-Contents only V-Value & /
label @ISNA(val) gives True if val is NAQ
O/C clear worksheet N-all formulas same reference
@LN(val) natural logG
E/D delete R or C R-all formulas relative (
reference @LOG10(val) Log base 10Q
O/E edit )-exit options +
@LOOKUP(val,rng) compare val to tableQ
O ESC destructive backspace /W set window -
@MAX(list) return Max value from listJ
H/F format a cell H-Horiz.window V-Vert. 4
window @MIN(list) return min value from listI
G D-Default G-General I-Integer 1-remove windows S-Sync $
windows @NA return NAQ
O L-L.justify R-R.justify $-Dollars U-Unsync windows ,
@NOT(state) return True if state is FQ
O *-Graphic /- fill cell with next character +
@NPV(disc,rng) net present value ofQ
O/G global parameters
@TRUE returns TRUEQ
O C-G.C.width F-G.format A-G.attrib. FUNCTIONS
@OR(list) logical orQ
O O-calculate order.....R or C first @ABS(val) absolute value
@PI gives piQ
O R-recalculation A(uto) M(anual) @AND(list) logical and )
@ROUND(val,n) rounds val to n placesQ
O/I insert R or C @AVERAGE(list) gives arith. avg. $
@ROW gives current rowQ
O/L set individual col. width @CHOOSE(index,list) gives list val.
@SQRT(val) square rootQ
O/M move a row or column @COL gives current column
@SUM(list) sum of listQ
O/P invoke print subsystem @COUNT(range) gives # of vals.in rng. -
========================================Q
O/S invoke file subsystem @ERROR returns ERROR (
#-copies coord value !-calculateQ
O/T set titles @EXP(val) gives e to val -
TAB go to next unprotect fieldQ
O H-Horizontal tites V-Vertical title @FALSE returns FALSE -
CTRL-Y go to prev unprotect fieldQ
O B-Both H. & V. N-remove titles @INT(val) gives [val] )
; go to alternate windowQ
O<esc>Q setup string for compressed printing (
<esc> destructive backspace